<?xml version="1.0" encoding="ascii"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
          "DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>jld.tools.db</title>
  <link rel="stylesheet" href="epydoc.css" type="text/css" />
  <script type="text/javascript" src="epydoc.js"></script>
</head>

<body bgcolor="white" text="black" link="blue" vlink="#204080"
      alink="#204080">
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="jld-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

      <th class="navbar" width="100%"></th>
  </tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="100%">
      <span class="breadcrumbs">
        <a href="jld-module.html">Package&nbsp;jld</a> ::
        <a href="jld.tools-module.html">Package&nbsp;tools</a> ::
        Module&nbsp;db
      </span>
    </td>
    <td>
      <table cellpadding="0" cellspacing="0">
        <!-- hide/show private -->
        <tr><td align="right"><span class="options">[<a href="javascript:void(0);" class="privatelink"
    onclick="toggle_private();">hide&nbsp;private</a>]</span></td></tr>
        <tr><td align="right"><span class="options"
            >[<a href="frames.html" target="_top">frames</a
            >]&nbsp;|&nbsp;<a href="jld.tools.db-pysrc.html"
            target="_top">no&nbsp;frames</a>]</span></td></tr>
      </table>
    </td>
  </tr>
</table>
<h1 class="epydoc">Source Code for <a href="jld.tools.db-module.html">Module jld.tools.db</a></h1>
<pre class="py-src">
<a name="L1"></a><tt class="py-lineno">  1</tt>  <tt class="py-line"><tt class="py-comment">#!/usr/bin/env python</tt> </tt>
<a name="L2"></a><tt class="py-lineno">  2</tt>  <tt class="py-line"><tt class="py-comment"></tt><tt class="py-docstring">""" Db tools</tt> </tt>
<a name="L3"></a><tt class="py-lineno">  3</tt>  <tt class="py-line"><tt class="py-docstring">    @author: Jean-Lou Dupont</tt> </tt>
<a name="L4"></a><tt class="py-lineno">  4</tt>  <tt class="py-line"><tt class="py-docstring">"""</tt> </tt>
<a name="L5"></a><tt class="py-lineno">  5</tt>  <tt class="py-line"> </tt>
<a name="L6"></a><tt class="py-lineno">  6</tt>  <tt class="py-line"><tt id="link-0" class="py-name" targets="Variable jld.__author__=jld-module.html#__author__,Variable jld.api.__author__=jld.api-module.html#__author__,Variable jld.api.delicious.__author__=jld.api.delicious-module.html#__author__,Variable jld.api.delicious_objects.__author__=jld.api.delicious_objects-module.html#__author__,Variable jld.api.gliffy.__author__=jld.api.gliffy-module.html#__author__,Variable jld.backup.delicious.__author__=jld.backup.delicious-module.html#__author__,Variable jld.backup.delicious_db.__author__=jld.backup.delicious_db-module.html#__author__,Variable jld.backup.delicious_defaults.__author__=jld.backup.delicious_defaults-module.html#__author__,Variable jld.backup.delicious_printer.__author__=jld.backup.delicious_printer-module.html#__author__,Variable jld.backup.delicious_ui.__author__=jld.backup.delicious_ui-module.html#__author__,Variable jld.backup.gliffy.__author__=jld.backup.gliffy-module.html#__author__,Variable jld.backup.gliffy_db.__author__=jld.backup.gliffy_db-module.html#__author__,Variable jld.backup.gliffy_defaults.__author__=jld.backup.gliffy_defaults-module.html#__author__,Variable jld.backup.gliffy_printer.__author__=jld.backup.gliffy_printer-module.html#__author__,Variable jld.backup.gliffy_ui.__author__=jld.backup.gliffy_ui-module.html#__author__,Variable jld.backup.mindmeister_db.__author__=jld.backup.mindmeister_db-module.html#__author__,Variable jld.backup.mindmeister_defaults.__author__=jld.backup.mindmeister_defaults-module.html#__author__,Variable jld.backup.mindmeister_printer.__author__=jld.backup.mindmeister_printer-module.html#__author__,Variable jld.backup.mindmeister_ui.__author__=jld.backup.mindmeister_ui-module.html#__author__,Variable jld.backup.mmd.__author__=jld.backup.mmd-module.html#__author__,Variable jld.cmd.__author__=jld.cmd-module.html#__author__,Variable jld.gdata.docs.__author__=jld.gdata.docs-module.html#__author__,Variable jld.tools.cmd_ui.__author__=jld.tools.cmd_ui-module.html#__author__,Variable jld.tools.daemon.__author__=jld.tools.daemon-module.html#__author__,Variable jld.tools.date.__author__=jld.tools.date-module.html#__author__,Variable jld.tools.db.__author__=jld.tools.db-module.html#__author__,Variable jld.tools.klass.__author__=jld.tools.klass-module.html#__author__,Variable jld.tools.logger.__author__=jld.tools.logger-module.html#__author__,Variable jld.tools.mos.__author__=jld.tools.mos-module.html#__author__,Variable jld.tools.printer.__author__=jld.tools.printer-module.html#__author__,Variable jld.tools.process.__author__=jld.tools.process-module.html#__author__"><a title="jld.__author__
jld.api.__author__
jld.api.delicious.__author__
jld.api.delicious_objects.__author__
jld.api.gliffy.__author__
jld.backup.delicious.__author__
jld.backup.delicious_db.__author__
jld.backup.delicious_defaults.__author__
jld.backup.delicious_printer.__author__
jld.backup.delicious_ui.__author__
jld.backup.gliffy.__author__
jld.backup.gliffy_db.__author__
jld.backup.gliffy_defaults.__author__
jld.backup.gliffy_printer.__author__
jld.backup.gliffy_ui.__author__
jld.backup.mindmeister_db.__author__
jld.backup.mindmeister_defaults.__author__
jld.backup.mindmeister_printer.__author__
jld.backup.mindmeister_ui.__author__
jld.backup.mmd.__author__
jld.cmd.__author__
jld.gdata.docs.__author__
jld.tools.cmd_ui.__author__
jld.tools.daemon.__author__
jld.tools.date.__author__
jld.tools.db.__author__
jld.tools.klass.__author__
jld.tools.logger.__author__
jld.tools.mos.__author__
jld.tools.printer.__author__
jld.tools.process.__author__" class="py-name" href="#" onclick="return doclink('link-0', '__author__', 'link-0');">__author__</a></tt>  <tt class="py-op">=</tt> <tt class="py-string">"Jean-Lou Dupont"</tt> </tt>
<a name="L7"></a><tt class="py-lineno">  7</tt>  <tt class="py-line"><tt class="py-name">__version__</tt> <tt class="py-op">=</tt> <tt class="py-string">"$Id: jld.tools.db-pysrc.html 763 2008-12-17 18:15:28Z JeanLou.Dupont $"</tt> </tt>
<a name="L8"></a><tt class="py-lineno">  8</tt>  <tt class="py-line"> </tt>
<a name="L9"></a><tt class="py-lineno">  9</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">os</tt> </tt>
<a name="L10"></a><tt class="py-lineno"> 10</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt class="py-name">sqlobject</tt> <tt class="py-keyword">import</tt> <tt class="py-op">*</tt> </tt>
<a name="L11"></a><tt class="py-lineno"> 11</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">sqlite3</tt> <tt class="py-keyword">as</tt> <tt class="py-name">sql</tt> </tt>
<a name="L12"></a><tt class="py-lineno"> 12</tt>  <tt class="py-line"> </tt>
<a name="L13"></a><tt class="py-lineno"> 13</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt id="link-1" class="py-name" targets="Package jld=jld-module.html"><a title="jld" class="py-name" href="#" onclick="return doclink('link-1', 'jld', 'link-1');">jld</a></tt><tt class="py-op">.</tt><tt id="link-2" class="py-name" targets="Package jld.api=jld.api-module.html"><a title="jld.api" class="py-name" href="#" onclick="return doclink('link-2', 'api', 'link-2');">api</a></tt> <tt class="py-keyword">as</tt> <tt id="link-3" class="py-name"><a title="jld.api" class="py-name" href="#" onclick="return doclink('link-3', 'api', 'link-2');">api</a></tt> </tt>
<a name="L14"></a><tt class="py-lineno"> 14</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt id="link-4" class="py-name"><a title="jld" class="py-name" href="#" onclick="return doclink('link-4', 'jld', 'link-1');">jld</a></tt><tt class="py-op">.</tt><tt id="link-5" class="py-name" targets="Package jld.tools=jld.tools-module.html"><a title="jld.tools" class="py-name" href="#" onclick="return doclink('link-5', 'tools', 'link-5');">tools</a></tt><tt class="py-op">.</tt><tt id="link-6" class="py-name" targets="Module jld.tools.mos=jld.tools.mos-module.html"><a title="jld.tools.mos" class="py-name" href="#" onclick="return doclink('link-6', 'mos', 'link-6');">mos</a></tt> <tt class="py-keyword">as</tt> <tt id="link-7" class="py-name"><a title="jld.tools.mos" class="py-name" href="#" onclick="return doclink('link-7', 'mos', 'link-6');">mos</a></tt>  </tt>
<a name="formatSqliteURI"></a><div id="formatSqliteURI-def"><a name="L15"></a><tt class="py-lineno"> 15</tt>  <tt class="py-line"> </tt>
<a name="L16"></a><tt class="py-lineno"> 16</tt> <a class="py-toggle" href="#" id="formatSqliteURI-toggle" onclick="return toggle('formatSqliteURI');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="jld.tools.db-module.html#formatSqliteURI">formatSqliteURI</a><tt class="py-op">(</tt> <tt class="py-param">path</tt> <tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="formatSqliteURI-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="formatSqliteURI-expanded"><a name="L17"></a><tt class="py-lineno"> 17</tt>  <tt class="py-line">    <tt class="py-docstring">""" Formats a filesystem path</tt> </tt>
<a name="L18"></a><tt class="py-lineno"> 18</tt>  <tt class="py-line"><tt class="py-docstring">        to a valid Sqlite URI.</tt> </tt>
<a name="L19"></a><tt class="py-lineno"> 19</tt>  <tt class="py-line"><tt class="py-docstring">        Under Windows, the backward slash \</tt> </tt>
<a name="L20"></a><tt class="py-lineno"> 20</tt>  <tt class="py-line"><tt class="py-docstring">        must be replaced with forward slash /</tt> </tt>
<a name="L21"></a><tt class="py-lineno"> 21</tt>  <tt class="py-line"><tt class="py-docstring">        as well as replacing the semicolon :</tt> </tt>
<a name="L22"></a><tt class="py-lineno"> 22</tt>  <tt class="py-line"><tt class="py-docstring">        to a pipe character |.</tt> </tt>
<a name="L23"></a><tt class="py-lineno"> 23</tt>  <tt class="py-line"><tt class="py-docstring">        For a complete URI, just prepend sqlite:///</tt> </tt>
<a name="L24"></a><tt class="py-lineno"> 24</tt>  <tt class="py-line"><tt class="py-docstring">        </tt> </tt>
<a name="L25"></a><tt class="py-lineno"> 25</tt>  <tt class="py-line"><tt class="py-docstring">        @param path: the input filesystem path</tt> </tt>
<a name="L26"></a><tt class="py-lineno"> 26</tt>  <tt class="py-line"><tt class="py-docstring">        @return: the formatted Sqlite URI </tt> </tt>
<a name="L27"></a><tt class="py-lineno"> 27</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L28"></a><tt class="py-lineno"> 28</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt id="link-8" class="py-name" targets="Variable jld.api.delicious.path=jld.api.delicious-module.html#path,Variable jld.backup.delicious.path=jld.backup.delicious-module.html#path,Variable jld.backup.gliffy.path=jld.backup.gliffy-module.html#path,Variable jld.backup.mm.path=jld.backup.mm-module.html#path,Variable jld.backup.mmd.path=jld.backup.mmd-module.html#path"><a title="jld.api.delicious.path
jld.backup.delicious.path
jld.backup.gliffy.path
jld.backup.mm.path
jld.backup.mmd.path" class="py-name" href="#" onclick="return doclink('link-8', 'path', 'link-8');">path</a></tt> <tt class="py-keyword">is</tt> <tt class="py-string">':memory:'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L29"></a><tt class="py-lineno"> 29</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-9" class="py-name"><a title="jld.api.delicious.path
jld.backup.delicious.path
jld.backup.gliffy.path
jld.backup.mm.path
jld.backup.mmd.path" class="py-name" href="#" onclick="return doclink('link-9', 'path', 'link-8');">path</a></tt> </tt>
<a name="L30"></a><tt class="py-lineno"> 30</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt>  <tt id="link-10" class="py-name"><a title="jld.api.delicious.path
jld.backup.delicious.path
jld.backup.gliffy.path
jld.backup.mm.path
jld.backup.mmd.path" class="py-name" href="#" onclick="return doclink('link-10', 'path', 'link-8');">path</a></tt><tt class="py-op">.</tt><tt class="py-name">replace</tt><tt class="py-op">(</tt><tt class="py-string">'\\'</tt><tt class="py-op">,</tt><tt class="py-string">'/'</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt class="py-name">replace</tt><tt class="py-op">(</tt><tt class="py-string">':'</tt><tt class="py-op">,</tt><tt class="py-string">'|'</tt><tt class="py-op">)</tt> </tt>
</div><a name="L31"></a><tt class="py-lineno"> 31</tt>  <tt class="py-line"> </tt>
<a name="BaseSQLObjectDb"></a><div id="BaseSQLObjectDb-def"><a name="L32"></a><tt class="py-lineno"> 32</tt>  <tt class="py-line"> </tt>
<a name="L33"></a><tt class="py-lineno"> 33</tt>  <tt class="py-line"> </tt>
<a name="L34"></a><tt class="py-lineno"> 34</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb-toggle" onclick="return toggle('BaseSQLObjectDb');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb-class.html">BaseSQLObjectDb</a><tt class="py-op">(</tt><tt class="py-base-class">object</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="BaseSQLObjectDb-expanded"><a name="L35"></a><tt class="py-lineno"> 35</tt>  <tt class="py-line">    <tt class="py-docstring">""" Base SQLObject Database Initialization class</tt> </tt>
<a name="L36"></a><tt class="py-lineno"> 36</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L37"></a><tt class="py-lineno"> 37</tt>  <tt class="py-line">     </tt>
<a name="BaseSQLObjectDb.__init__"></a><div id="BaseSQLObjectDb.__init__-def"><a name="L38"></a><tt class="py-lineno"> 38</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb.__init__-toggle" onclick="return toggle('BaseSQLObjectDb.__init__');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb-class.html#__init__">__init__</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">filepath</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb.__init__-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="BaseSQLObjectDb.__init__-expanded"><a name="L39"></a><tt class="py-lineno"> 39</tt>  <tt class="py-line">        <tt class="py-docstring">""" Constructor</tt> </tt>
<a name="L40"></a><tt class="py-lineno"> 40</tt>  <tt class="py-line"><tt class="py-docstring">            @param filepath: filesystem path of the database file </tt> </tt>
<a name="L41"></a><tt class="py-lineno"> 41</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L42"></a><tt class="py-lineno"> 42</tt>  <tt class="py-line">        <tt class="py-comment"># verify that the db file exists first</tt> </tt>
<a name="L43"></a><tt class="py-lineno"> 43</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-11" class="py-name" targets="Method jld.tools.db.BaseSQLObjectDb._createDb()=jld.tools.db.BaseSQLObjectDb-class.html#_createDb,Method jld.tools.db.BaseSQLObjectDb2._createDb()=jld.tools.db.BaseSQLObjectDb2-class.html#_createDb"><a title="jld.tools.db.BaseSQLObjectDb._createDb
jld.tools.db.BaseSQLObjectDb2._createDb" class="py-name" href="#" onclick="return doclink('link-11', '_createDb', 'link-11');">_createDb</a></tt><tt class="py-op">(</tt><tt id="link-12" class="py-name" targets="Variable jld.backup.delicious_messages.Delicious_Messages.filepath=jld.backup.delicious_messages.Delicious_Messages-class.html#filepath,Variable jld.backup.gliffy_messages.Gliffy_Messages.filepath=jld.backup.gliffy_messages.Gliffy_Messages-class.html#filepath,Variable jld.backup.mindmeister_messages.MM_Messages.filepath=jld.backup.mindmeister_messages.MM_Messages-class.html#filepath,Variable jld.backup.mmd.mmdMessages.filepath=jld.backup.mmd.mmdMessages-class.html#filepath"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-12', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">)</tt> </tt>
<a name="L44"></a><tt class="py-lineno"> 44</tt>  <tt class="py-line"> </tt>
<a name="L45"></a><tt class="py-lineno"> 45</tt>  <tt class="py-line">        <tt class="py-comment">#on windows, watch-out for the \</tt> </tt>
<a name="L46"></a><tt class="py-lineno"> 46</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-comment">#which are interpreted as escape code by SqlObject</tt> </tt>
<a name="L47"></a><tt class="py-lineno"> 47</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-comment">#also, the : on windows should be switched to |        </tt> </tt>
<a name="L48"></a><tt class="py-lineno"> 48</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-name">sqlobject_filepath</tt> <tt class="py-op">=</tt> <tt id="link-13" class="py-name" targets="Function jld.tools.db.formatSqliteURI()=jld.tools.db-module.html#formatSqliteURI"><a title="jld.tools.db.formatSqliteURI" class="py-name" href="#" onclick="return doclink('link-13', 'formatSqliteURI', 'link-13');">formatSqliteURI</a></tt><tt class="py-op">(</tt><tt id="link-14" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-14', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">)</tt> </tt>
<a name="L49"></a><tt class="py-lineno"> 49</tt>  <tt class="py-line"> </tt>
<a name="L50"></a><tt class="py-lineno"> 50</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L51"></a><tt class="py-lineno"> 51</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt id="link-15" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-15', 'filepath', 'link-12');">filepath</a></tt> <tt class="py-op">==</tt> <tt class="py-string">':memory:'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L52"></a><tt class="py-lineno"> 52</tt>  <tt class="py-line">                <tt class="py-name">connection_string</tt> <tt class="py-op">=</tt> <tt class="py-string">'sqlite:/:memory:'</tt> </tt>
<a name="L53"></a><tt class="py-lineno"> 53</tt>  <tt class="py-line">            <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L54"></a><tt class="py-lineno"> 54</tt>  <tt class="py-line">                <tt class="py-name">connection_string</tt> <tt class="py-op">=</tt> <tt class="py-string">'sqlite:///'</tt> <tt class="py-op">+</tt> <tt class="py-name">sqlobject_filepath</tt> </tt>
<a name="L55"></a><tt class="py-lineno"> 55</tt>  <tt class="py-line">            <tt class="py-name">connection</tt> <tt class="py-op">=</tt> <tt class="py-name">connectionForURI</tt><tt class="py-op">(</tt> <tt class="py-name">connection_string</tt> <tt class="py-op">)</tt> </tt>
<a name="L56"></a><tt class="py-lineno"> 56</tt>  <tt class="py-line">            <tt id="link-16" class="py-name" targets="Variable jld.backup.delicious_db.sqlhub=jld.backup.delicious_db-module.html#sqlhub,Variable jld.backup.gliffy_db.sqlhub=jld.backup.gliffy_db-module.html#sqlhub,Variable jld.backup.mindmeister_db.sqlhub=jld.backup.mindmeister_db-module.html#sqlhub,Variable jld.tools.db.sqlhub=jld.tools.db-module.html#sqlhub"><a title="jld.backup.delicious_db.sqlhub
jld.backup.gliffy_db.sqlhub
jld.backup.mindmeister_db.sqlhub
jld.tools.db.sqlhub" class="py-name" href="#" onclick="return doclink('link-16', 'sqlhub', 'link-16');">sqlhub</a></tt><tt class="py-op">.</tt><tt class="py-name">processConnection</tt> <tt class="py-op">=</tt> <tt class="py-name">connection</tt> </tt>
<a name="L57"></a><tt class="py-lineno"> 57</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt> <tt class="py-name">Exception</tt><tt class="py-op">,</tt><tt class="py-name">e</tt><tt class="py-op">:</tt> </tt>
<a name="L58"></a><tt class="py-lineno"> 58</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt id="link-17" class="py-name"><a title="jld.api" class="py-name" href="#" onclick="return doclink('link-17', 'api', 'link-2');">api</a></tt><tt class="py-op">.</tt><tt id="link-18" class="py-name" targets="Class jld.api.ErrorDb=jld.api.ErrorDb-class.html"><a title="jld.api.ErrorDb" class="py-name" href="#" onclick="return doclink('link-18', 'ErrorDb', 'link-18');">ErrorDb</a></tt><tt class="py-op">(</tt> <tt class="py-name">e</tt><tt class="py-op">,</tt> <tt class="py-op">{</tt><tt class="py-string">'file'</tt><tt class="py-op">:</tt><tt id="link-19" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-19', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">}</tt> <tt class="py-op">)</tt> </tt>
<a name="L59"></a><tt class="py-lineno"> 59</tt>  <tt class="py-line"> </tt>
<a name="L60"></a><tt class="py-lineno"> 60</tt>  <tt class="py-line">        <tt class="py-comment">#table already exists ... no big deal</tt> </tt>
<a name="L61"></a><tt class="py-lineno"> 61</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-20" class="py-name" targets="Method jld.backup.delicious_db.Db.initTable()=jld.backup.delicious_db.Db-class.html#initTable,Method jld.backup.gliffy_db.Db.initTable()=jld.backup.gliffy_db.Db-class.html#initTable,Method jld.backup.mindmeister_db.Db.initTable()=jld.backup.mindmeister_db.Db-class.html#initTable,Method jld.tools.db.BaseSQLObjectDb.initTable()=jld.tools.db.BaseSQLObjectDb-class.html#initTable,Method jld.tools.db.BaseSQLObjectDb2.initTable()=jld.tools.db.BaseSQLObjectDb2-class.html#initTable"><a title="jld.backup.delicious_db.Db.initTable
jld.backup.gliffy_db.Db.initTable
jld.backup.mindmeister_db.Db.initTable
jld.tools.db.BaseSQLObjectDb.initTable
jld.tools.db.BaseSQLObjectDb2.initTable" class="py-name" href="#" onclick="return doclink('link-20', 'initTable', 'link-20');">initTable</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
</div><a name="L62"></a><tt class="py-lineno"> 62</tt>  <tt class="py-line">         </tt>
<a name="BaseSQLObjectDb.initTable"></a><div id="BaseSQLObjectDb.initTable-def"><a name="L63"></a><tt class="py-lineno"> 63</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb.initTable-toggle" onclick="return toggle('BaseSQLObjectDb.initTable');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb-class.html#initTable">initTable</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb.initTable-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="BaseSQLObjectDb.initTable-expanded"><a name="L64"></a><tt class="py-lineno"> 64</tt>  <tt class="py-line">        <tt class="py-docstring">""" Strategy Method: initializes the tables </tt> </tt>
<a name="L65"></a><tt class="py-lineno"> 65</tt>  <tt class="py-line"><tt class="py-docstring">            of this database</tt> </tt>
<a name="L66"></a><tt class="py-lineno"> 66</tt>  <tt class="py-line"><tt class="py-docstring">            </tt> </tt>
<a name="L67"></a><tt class="py-lineno"> 67</tt>  <tt class="py-line"><tt class="py-docstring">            E.g. Diagrams.createTable(ifNotExists=True)</tt> </tt>
<a name="L68"></a><tt class="py-lineno"> 68</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L69"></a><tt class="py-lineno"> 69</tt>  <tt class="py-line">        <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">'must sub-class'</tt><tt class="py-op">)</tt> </tt>
</div><a name="L70"></a><tt class="py-lineno"> 70</tt>  <tt class="py-line">         </tt>
<a name="L71"></a><tt class="py-lineno"> 71</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">classmethod</tt> </tt>
<a name="BaseSQLObjectDb.deleteDb"></a><div id="BaseSQLObjectDb.deleteDb-def"><a name="L72"></a><tt class="py-lineno"> 72</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb.deleteDb-toggle" onclick="return toggle('BaseSQLObjectDb.deleteDb');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb-class.html#deleteDb">deleteDb</a><tt class="py-op">(</tt><tt class="py-param">cls</tt><tt class="py-op">,</tt> <tt class="py-param">filepath</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb.deleteDb-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="BaseSQLObjectDb.deleteDb-expanded"><a name="L73"></a><tt class="py-lineno"> 73</tt>  <tt class="py-line">        <tt class="py-docstring">""" Deletes the corresponding filesystem db file</tt> </tt>
<a name="L74"></a><tt class="py-lineno"> 74</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L75"></a><tt class="py-lineno"> 75</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt>    <tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">remove</tt><tt class="py-op">(</tt><tt id="link-21" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-21', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">)</tt> </tt>
<a name="L76"></a><tt class="py-lineno"> 76</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt><tt class="py-op">:</tt> <tt class="py-keyword">pass</tt> </tt>
</div><a name="L77"></a><tt class="py-lineno"> 77</tt>  <tt class="py-line">     </tt>
<a name="BaseSQLObjectDb._createDb"></a><div id="BaseSQLObjectDb._createDb-def"><a name="L78"></a><tt class="py-lineno"> 78</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb._createDb-toggle" onclick="return toggle('BaseSQLObjectDb._createDb');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb-class.html#_createDb">_createDb</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">filepath</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb._createDb-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="BaseSQLObjectDb._createDb-expanded"><a name="L79"></a><tt class="py-lineno"> 79</tt>  <tt class="py-line">        <tt class="py-docstring">""" Handles the creation, if necessary,</tt> </tt>
<a name="L80"></a><tt class="py-lineno"> 80</tt>  <tt class="py-line"><tt class="py-docstring">            of the database file. The tricky part</tt> </tt>
<a name="L81"></a><tt class="py-lineno"> 81</tt>  <tt class="py-line"><tt class="py-docstring">            being the creation of the folder hierarchy</tt> </tt>
<a name="L82"></a><tt class="py-lineno"> 82</tt>  <tt class="py-line"><tt class="py-docstring">            (if required).</tt> </tt>
<a name="L83"></a><tt class="py-lineno"> 83</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L84"></a><tt class="py-lineno"> 84</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt id="link-22" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-22', 'filepath', 'link-12');">filepath</a></tt> <tt class="py-op">!=</tt> <tt class="py-string">':memory:'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L85"></a><tt class="py-lineno"> 85</tt>  <tt class="py-line">            <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L86"></a><tt class="py-lineno"> 86</tt>  <tt class="py-line">                <tt id="link-23" class="py-name"><a title="jld.tools.mos" class="py-name" href="#" onclick="return doclink('link-23', 'mos', 'link-6');">mos</a></tt><tt class="py-op">.</tt><tt id="link-24" class="py-name" targets="Function jld.tools.mos.createPathIfNotExists()=jld.tools.mos-module.html#createPathIfNotExists"><a title="jld.tools.mos.createPathIfNotExists" class="py-name" href="#" onclick="return doclink('link-24', 'createPathIfNotExists', 'link-24');">createPathIfNotExists</a></tt><tt class="py-op">(</tt><tt id="link-25" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-25', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">)</tt> </tt>
<a name="L87"></a><tt class="py-lineno"> 87</tt>  <tt class="py-line">            <tt class="py-keyword">except</tt> <tt class="py-name">Exception</tt><tt class="py-op">,</tt><tt class="py-name">e</tt><tt class="py-op">:</tt> </tt>
<a name="L88"></a><tt class="py-lineno"> 88</tt>  <tt class="py-line">                <tt class="py-keyword">print</tt> <tt class="py-name">e</tt> </tt>
<a name="L89"></a><tt class="py-lineno"> 89</tt>  <tt class="py-line">                <tt class="py-keyword">raise</tt> <tt id="link-26" class="py-name"><a title="jld.api" class="py-name" href="#" onclick="return doclink('link-26', 'api', 'link-2');">api</a></tt><tt class="py-op">.</tt><tt id="link-27" class="py-name"><a title="jld.api.ErrorDb" class="py-name" href="#" onclick="return doclink('link-27', 'ErrorDb', 'link-18');">ErrorDb</a></tt><tt class="py-op">(</tt> <tt class="py-name">e</tt><tt class="py-op">,</tt> <tt class="py-op">{</tt><tt class="py-string">'file'</tt><tt class="py-op">:</tt><tt id="link-28" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-28', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">}</tt> <tt class="py-op">)</tt> </tt>
<a name="L90"></a><tt class="py-lineno"> 90</tt>  <tt class="py-line">         </tt>
<a name="L91"></a><tt class="py-lineno"> 91</tt>  <tt class="py-line">        <tt class="py-comment"># lastly, try to create the db</tt> </tt>
<a name="L92"></a><tt class="py-lineno"> 92</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L93"></a><tt class="py-lineno"> 93</tt>  <tt class="py-line">            <tt class="py-name">dbfile</tt> <tt class="py-op">=</tt> <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">connect</tt><tt class="py-op">(</tt> <tt id="link-29" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-29', 'filepath', 'link-12');">filepath</a></tt> <tt class="py-op">)</tt> </tt>
<a name="L94"></a><tt class="py-lineno"> 94</tt>  <tt class="py-line">            <tt class="py-name">dbfile</tt><tt class="py-op">.</tt><tt class="py-name">close</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L95"></a><tt class="py-lineno"> 95</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt> <tt class="py-name">Exception</tt><tt class="py-op">,</tt><tt class="py-name">e</tt><tt class="py-op">:</tt> </tt>
<a name="L96"></a><tt class="py-lineno"> 96</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt id="link-30" class="py-name"><a title="jld.api" class="py-name" href="#" onclick="return doclink('link-30', 'api', 'link-2');">api</a></tt><tt class="py-op">.</tt><tt id="link-31" class="py-name"><a title="jld.api.ErrorDb" class="py-name" href="#" onclick="return doclink('link-31', 'ErrorDb', 'link-18');">ErrorDb</a></tt><tt class="py-op">(</tt> <tt class="py-name">e</tt><tt class="py-op">,</tt> <tt class="py-op">{</tt><tt class="py-string">'file'</tt><tt class="py-op">:</tt><tt id="link-32" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-32', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">}</tt> <tt class="py-op">)</tt> </tt>
</div></div><a name="L97"></a><tt class="py-lineno"> 97</tt>  <tt class="py-line">        </tt>
<a name="BaseSQLObjectDb2"></a><div id="BaseSQLObjectDb2-def"><a name="L98"></a><tt class="py-lineno"> 98</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb2-toggle" onclick="return toggle('BaseSQLObjectDb2');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb2-class.html">BaseSQLObjectDb2</a><tt class="py-op">(</tt><tt class="py-base-class">object</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb2-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="BaseSQLObjectDb2-expanded"><a name="L99"></a><tt class="py-lineno"> 99</tt>  <tt class="py-line">    <tt class="py-docstring">""" Base SQLObject Database Initialization class</tt> </tt>
<a name="L100"></a><tt class="py-lineno">100</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L101"></a><tt class="py-lineno">101</tt>  <tt class="py-line">     </tt>
<a name="BaseSQLObjectDb2.__init__"></a><div id="BaseSQLObjectDb2.__init__-def"><a name="L102"></a><tt class="py-lineno">102</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb2.__init__-toggle" onclick="return toggle('BaseSQLObjectDb2.__init__');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb2-class.html#__init__">__init__</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">filepath</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb2.__init__-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="BaseSQLObjectDb2.__init__-expanded"><a name="L103"></a><tt class="py-lineno">103</tt>  <tt class="py-line">        <tt class="py-docstring">""" Constructor</tt> </tt>
<a name="L104"></a><tt class="py-lineno">104</tt>  <tt class="py-line"><tt class="py-docstring">            @param filepath: filesystem path of the database file </tt> </tt>
<a name="L105"></a><tt class="py-lineno">105</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L106"></a><tt class="py-lineno">106</tt>  <tt class="py-line">        <tt class="py-comment"># verify that the db file exists first</tt> </tt>
<a name="L107"></a><tt class="py-lineno">107</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-33" class="py-name"><a title="jld.tools.db.BaseSQLObjectDb._createDb
jld.tools.db.BaseSQLObjectDb2._createDb" class="py-name" href="#" onclick="return doclink('link-33', '_createDb', 'link-11');">_createDb</a></tt><tt class="py-op">(</tt><tt id="link-34" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-34', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">)</tt> </tt>
<a name="L108"></a><tt class="py-lineno">108</tt>  <tt class="py-line"> </tt>
<a name="L109"></a><tt class="py-lineno">109</tt>  <tt class="py-line">        <tt class="py-comment">#on windows, watch-out for the \</tt> </tt>
<a name="L110"></a><tt class="py-lineno">110</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-comment">#which are interpreted as escape code by SqlObject</tt> </tt>
<a name="L111"></a><tt class="py-lineno">111</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-comment">#also, the : on windows should be switched to |        </tt> </tt>
<a name="L112"></a><tt class="py-lineno">112</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-name">sqlobject_filepath</tt> <tt class="py-op">=</tt> <tt id="link-35" class="py-name"><a title="jld.tools.db.formatSqliteURI" class="py-name" href="#" onclick="return doclink('link-35', 'formatSqliteURI', 'link-13');">formatSqliteURI</a></tt><tt class="py-op">(</tt><tt id="link-36" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-36', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">)</tt> </tt>
<a name="L113"></a><tt class="py-lineno">113</tt>  <tt class="py-line"> </tt>
<a name="L114"></a><tt class="py-lineno">114</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L115"></a><tt class="py-lineno">115</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt id="link-37" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-37', 'filepath', 'link-12');">filepath</a></tt> <tt class="py-op">==</tt> <tt class="py-string">':memory:'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L116"></a><tt class="py-lineno">116</tt>  <tt class="py-line">                <tt class="py-name">connection_string</tt> <tt class="py-op">=</tt> <tt class="py-string">'sqlite:/:memory:'</tt> </tt>
<a name="L117"></a><tt class="py-lineno">117</tt>  <tt class="py-line">            <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L118"></a><tt class="py-lineno">118</tt>  <tt class="py-line">                <tt class="py-name">connection_string</tt> <tt class="py-op">=</tt> <tt class="py-string">'sqlite:///'</tt> <tt class="py-op">+</tt> <tt class="py-name">sqlobject_filepath</tt> </tt>
<a name="L119"></a><tt class="py-lineno">119</tt>  <tt class="py-line">            <tt class="py-name">connection</tt> <tt class="py-op">=</tt> <tt class="py-name">connectionForURI</tt><tt class="py-op">(</tt> <tt class="py-name">connection_string</tt> <tt class="py-op">)</tt> </tt>
<a name="L120"></a><tt class="py-lineno">120</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">hub</tt> <tt class="py-op">=</tt> <tt class="py-name">dbconnection</tt><tt class="py-op">.</tt><tt class="py-name">ConnectionHub</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L121"></a><tt class="py-lineno">121</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">hub</tt><tt class="py-op">.</tt><tt class="py-name">processConnection</tt> <tt class="py-op">=</tt> <tt class="py-name">connection</tt> </tt>
<a name="L122"></a><tt class="py-lineno">122</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt> <tt class="py-name">Exception</tt><tt class="py-op">,</tt><tt class="py-name">e</tt><tt class="py-op">:</tt> </tt>
<a name="L123"></a><tt class="py-lineno">123</tt>  <tt class="py-line">            <tt class="py-keyword">print</tt> <tt class="py-name">e</tt> </tt>
<a name="L124"></a><tt class="py-lineno">124</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt id="link-38" class="py-name"><a title="jld.api" class="py-name" href="#" onclick="return doclink('link-38', 'api', 'link-2');">api</a></tt><tt class="py-op">.</tt><tt id="link-39" class="py-name"><a title="jld.api.ErrorDb" class="py-name" href="#" onclick="return doclink('link-39', 'ErrorDb', 'link-18');">ErrorDb</a></tt><tt class="py-op">(</tt> <tt class="py-name">e</tt><tt class="py-op">,</tt> <tt class="py-op">{</tt><tt class="py-string">'file'</tt><tt class="py-op">:</tt><tt id="link-40" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-40', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">}</tt> <tt class="py-op">)</tt> </tt>
<a name="L125"></a><tt class="py-lineno">125</tt>  <tt class="py-line"> </tt>
<a name="L126"></a><tt class="py-lineno">126</tt>  <tt class="py-line">        <tt class="py-comment">#table already exists ... no big deal</tt> </tt>
<a name="L127"></a><tt class="py-lineno">127</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-41" class="py-name"><a title="jld.backup.delicious_db.Db.initTable
jld.backup.gliffy_db.Db.initTable
jld.backup.mindmeister_db.Db.initTable
jld.tools.db.BaseSQLObjectDb.initTable
jld.tools.db.BaseSQLObjectDb2.initTable" class="py-name" href="#" onclick="return doclink('link-41', 'initTable', 'link-20');">initTable</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">)</tt> </tt>
</div><a name="L128"></a><tt class="py-lineno">128</tt>  <tt class="py-line">         </tt>
<a name="BaseSQLObjectDb2.initTable"></a><div id="BaseSQLObjectDb2.initTable-def"><a name="L129"></a><tt class="py-lineno">129</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb2.initTable-toggle" onclick="return toggle('BaseSQLObjectDb2.initTable');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb2-class.html#initTable">initTable</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">connection</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb2.initTable-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="BaseSQLObjectDb2.initTable-expanded"><a name="L130"></a><tt class="py-lineno">130</tt>  <tt class="py-line">        <tt class="py-docstring">""" Strategy Method: initializes the tables </tt> </tt>
<a name="L131"></a><tt class="py-lineno">131</tt>  <tt class="py-line"><tt class="py-docstring">            of this database</tt> </tt>
<a name="L132"></a><tt class="py-lineno">132</tt>  <tt class="py-line"><tt class="py-docstring">            </tt> </tt>
<a name="L133"></a><tt class="py-lineno">133</tt>  <tt class="py-line"><tt class="py-docstring">            E.g. Diagrams.createTable(ifNotExists=True)</tt> </tt>
<a name="L134"></a><tt class="py-lineno">134</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L135"></a><tt class="py-lineno">135</tt>  <tt class="py-line">        <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">'must sub-class'</tt><tt class="py-op">)</tt> </tt>
</div><a name="L136"></a><tt class="py-lineno">136</tt>  <tt class="py-line">         </tt>
<a name="L137"></a><tt class="py-lineno">137</tt>  <tt class="py-line">    <tt class="py-decorator">@</tt><tt class="py-decorator">classmethod</tt> </tt>
<a name="BaseSQLObjectDb2.deleteDb"></a><div id="BaseSQLObjectDb2.deleteDb-def"><a name="L138"></a><tt class="py-lineno">138</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb2.deleteDb-toggle" onclick="return toggle('BaseSQLObjectDb2.deleteDb');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb2-class.html#deleteDb">deleteDb</a><tt class="py-op">(</tt><tt class="py-param">cls</tt><tt class="py-op">,</tt> <tt class="py-param">filepath</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb2.deleteDb-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="BaseSQLObjectDb2.deleteDb-expanded"><a name="L139"></a><tt class="py-lineno">139</tt>  <tt class="py-line">        <tt class="py-docstring">""" Deletes the corresponding filesystem db file</tt> </tt>
<a name="L140"></a><tt class="py-lineno">140</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L141"></a><tt class="py-lineno">141</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt>    <tt class="py-name">os</tt><tt class="py-op">.</tt><tt class="py-name">remove</tt><tt class="py-op">(</tt><tt id="link-42" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-42', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">)</tt> </tt>
<a name="L142"></a><tt class="py-lineno">142</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt><tt class="py-op">:</tt> <tt class="py-keyword">pass</tt> </tt>
</div><a name="L143"></a><tt class="py-lineno">143</tt>  <tt class="py-line">     </tt>
<a name="BaseSQLObjectDb2._createDb"></a><div id="BaseSQLObjectDb2._createDb-def"><a name="L144"></a><tt class="py-lineno">144</tt> <a class="py-toggle" href="#" id="BaseSQLObjectDb2._createDb-toggle" onclick="return toggle('BaseSQLObjectDb2._createDb');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="jld.tools.db.BaseSQLObjectDb2-class.html#_createDb">_createDb</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">filepath</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="BaseSQLObjectDb2._createDb-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="BaseSQLObjectDb2._createDb-expanded"><a name="L145"></a><tt class="py-lineno">145</tt>  <tt class="py-line">        <tt class="py-docstring">""" Handles the creation, if necessary,</tt> </tt>
<a name="L146"></a><tt class="py-lineno">146</tt>  <tt class="py-line"><tt class="py-docstring">            of the database file. The tricky part</tt> </tt>
<a name="L147"></a><tt class="py-lineno">147</tt>  <tt class="py-line"><tt class="py-docstring">            being the creation of the folder hierarchy</tt> </tt>
<a name="L148"></a><tt class="py-lineno">148</tt>  <tt class="py-line"><tt class="py-docstring">            (if required).</tt> </tt>
<a name="L149"></a><tt class="py-lineno">149</tt>  <tt class="py-line"><tt class="py-docstring">        """</tt> </tt>
<a name="L150"></a><tt class="py-lineno">150</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt id="link-43" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-43', 'filepath', 'link-12');">filepath</a></tt> <tt class="py-op">!=</tt> <tt class="py-string">':memory:'</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L151"></a><tt class="py-lineno">151</tt>  <tt class="py-line">            <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L152"></a><tt class="py-lineno">152</tt>  <tt class="py-line">                <tt id="link-44" class="py-name"><a title="jld.tools.mos" class="py-name" href="#" onclick="return doclink('link-44', 'mos', 'link-6');">mos</a></tt><tt class="py-op">.</tt><tt id="link-45" class="py-name"><a title="jld.tools.mos.createPathIfNotExists" class="py-name" href="#" onclick="return doclink('link-45', 'createPathIfNotExists', 'link-24');">createPathIfNotExists</a></tt><tt class="py-op">(</tt><tt id="link-46" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-46', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">)</tt> </tt>
<a name="L153"></a><tt class="py-lineno">153</tt>  <tt class="py-line">            <tt class="py-keyword">except</tt> <tt class="py-name">Exception</tt><tt class="py-op">,</tt><tt class="py-name">e</tt><tt class="py-op">:</tt> </tt>
<a name="L154"></a><tt class="py-lineno">154</tt>  <tt class="py-line">                <tt class="py-keyword">print</tt> <tt class="py-name">e</tt> </tt>
<a name="L155"></a><tt class="py-lineno">155</tt>  <tt class="py-line">                <tt class="py-keyword">raise</tt> <tt id="link-47" class="py-name"><a title="jld.api" class="py-name" href="#" onclick="return doclink('link-47', 'api', 'link-2');">api</a></tt><tt class="py-op">.</tt><tt id="link-48" class="py-name"><a title="jld.api.ErrorDb" class="py-name" href="#" onclick="return doclink('link-48', 'ErrorDb', 'link-18');">ErrorDb</a></tt><tt class="py-op">(</tt> <tt class="py-name">e</tt><tt class="py-op">,</tt> <tt class="py-op">{</tt><tt class="py-string">'file'</tt><tt class="py-op">:</tt><tt id="link-49" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-49', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">}</tt> <tt class="py-op">)</tt> </tt>
<a name="L156"></a><tt class="py-lineno">156</tt>  <tt class="py-line">         </tt>
<a name="L157"></a><tt class="py-lineno">157</tt>  <tt class="py-line">        <tt class="py-comment"># lastly, try to create the db</tt> </tt>
<a name="L158"></a><tt class="py-lineno">158</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L159"></a><tt class="py-lineno">159</tt>  <tt class="py-line">            <tt class="py-name">dbfile</tt> <tt class="py-op">=</tt> <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">connect</tt><tt class="py-op">(</tt> <tt id="link-50" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-50', 'filepath', 'link-12');">filepath</a></tt> <tt class="py-op">)</tt> </tt>
<a name="L160"></a><tt class="py-lineno">160</tt>  <tt class="py-line">            <tt class="py-name">dbfile</tt><tt class="py-op">.</tt><tt class="py-name">close</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L161"></a><tt class="py-lineno">161</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt> <tt class="py-name">Exception</tt><tt class="py-op">,</tt><tt class="py-name">e</tt><tt class="py-op">:</tt> </tt>
<a name="L162"></a><tt class="py-lineno">162</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt id="link-51" class="py-name"><a title="jld.api" class="py-name" href="#" onclick="return doclink('link-51', 'api', 'link-2');">api</a></tt><tt class="py-op">.</tt><tt id="link-52" class="py-name"><a title="jld.api.ErrorDb" class="py-name" href="#" onclick="return doclink('link-52', 'ErrorDb', 'link-18');">ErrorDb</a></tt><tt class="py-op">(</tt> <tt class="py-name">e</tt><tt class="py-op">,</tt> <tt class="py-op">{</tt><tt class="py-string">'file'</tt><tt class="py-op">:</tt><tt id="link-53" class="py-name"><a title="jld.backup.delicious_messages.Delicious_Messages.filepath
jld.backup.gliffy_messages.Gliffy_Messages.filepath
jld.backup.mindmeister_messages.MM_Messages.filepath
jld.backup.mmd.mmdMessages.filepath" class="py-name" href="#" onclick="return doclink('link-53', 'filepath', 'link-12');">filepath</a></tt><tt class="py-op">}</tt> <tt class="py-op">)</tt> </tt>
</div></div><a name="L163"></a><tt class="py-lineno">163</tt>  <tt class="py-line"> </tt><script type="text/javascript">
<!--
expandto(location.href);
// -->
</script>
</pre>
<br />
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="jld-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

      <th class="navbar" width="100%"></th>
  </tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%%">
  <tr>
    <td align="left" class="footer">
    Generated by Epydoc 3.0.1 on Wed Dec 17 13:12:02 2008
    </td>
    <td align="right" class="footer">
      <a target="mainFrame" href="http://epydoc.sourceforge.net"
        >http://epydoc.sourceforge.net</a>
    </td>
  </tr>
</table>

<script type="text/javascript">
  <!--
  // Private objects are initially displayed (because if
  // javascript is turned off then we want them to be
  // visible); but by default, we want to hide them.  So hide
  // them unless we have a cookie that says to show them.
  checkCookie();
  // -->
</script>
</body>
</html>
